CREATE TABLE `result` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `student_id` bigint(20) DEFAULT NULL,
  `result` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `student_number` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `student_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `student_major` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `student_class` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `student_school` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
BEGIN;
INSERT INTO `result` (`id`, `student_id`, `result`, `student_number`, `student_name`, `student_major`, `student_class`, `student_school`) VALUES (3, 2, 'P', '2', '2', '2', '2', '2');
INSERT INTO `result` (`id`, `student_id`, `result`, `student_number`, `student_name`, `student_major`, `student_class`, `student_school`) VALUES (4, 4, 'P', '001', '测试', 'XX', 'XX', 'XX');
COMMIT;